CREATE EXTERNAL TABLE jms_dim.dim_order_source_mapping(
  ordersource_code  string COMMENT '订单来源编码',
  ordersource_name  string COMMENT '订单来源名称')
COMMENT '多平台订单配置映射表'
stored as parquet
 LOCATION
   '/dw/hive/jms_dim.db/external/dim_order_source_mapping'
 TBLPROPERTIES (
        'discover.partitions' = 'false',
        'parquet.column.index.access' = 'true'
        );